CREATE EXTERNAL TABLE jms_dm.dm_cusc_demand_sign_network_summary_dt
(
    sign_early_scantime      string COMMENT '第一次签收时间',
    sign_early_scansitecode  string COMMENT '第一次签收网点code',
    sign_early_scansite_name string COMMENT '第一次签收网点名称',
    sign_agent_name          string COMMENT '签收网点所属代理区code',
    sign_agent_code          string COMMENT '签收网点所属代理区名称',
    sign_fran_code           string COMMENT '签收网点所属加盟商code',
    sign_fran_name           string COMMENT '签收网点所属加盟商名称',
    sign_provider_id         string COMMENT '签收网点所在省份id',
    sign_provider_desc       string COMMENT '签收网点所在省份名称',
    sign_city_id             string COMMENT '签收网点所在城市id',
    sign_city_desc           string COMMENT '签收网点所在城市名称',
    need_call_num            string COMMENT '应电联量',
    have_call_num            string COMMENT '已电联量',
    call_rate                string COMMENT '电联率',
    gt6_seconds              string COMMENT '通话时长大于6秒',
    gt6_seconds_rate         string COMMENT '6秒接通率',
    performance_bill_num     string COMMENT '履约票数',
    performance_bill_rate    string COMMENT '履约率'
)
    COMMENT '按需配送签收维度汇总(粒度网点)'
    PARTITIONED BY (
        dt string COMMENT '日期第一次签收时间')
    stored as parquet
    LOCATION
        '/dw/hive/jms_dm.db/external/dm_cusc_demand_sign_network_summary_dt'